/**
 *  http://roopindersingh.com/2008/12/10/spring-and-jetty-integration/
	http://roopindersingh.com/2008/12/10/spring-and-jetty-integration/
	http://blog.springsource.com/2007/01/23/dynamic-datasource-routing/
 */
package br.com.cliquetroca.embedded;

/**
 * @author paulo
 *
 */
public class Tabelas {
	
	public static final String USUARIO = "create table usuario( " +
		"login	varchar(10) constraint pk_usuario primary key, " +
		"senha	varchar(50), " +
		"status	smallint)";
	
	public static final String CLIENTE = "create table cliente( " +
		"id				integer constraint pk_cliente primary key, " +
		"nome			varchar(50) not null, " +
		"page			varchar(60) not null, " +
		"ddd_telefone	smallint, " +
		"telefone		integer, " +
		"ddd_celular	smallint, " +
		"celular		integer, " +
		"data_cadastro	date not null)";
	
	public static final String TABLE_SEQUENCE = "create table table_sequence( " +
		"sequence_name	varchar(50) constraint pk_table_sequence primary key, " +
		"sequence_value	integer)";
}